-
Re: Managing Smartsheet templates and workspaces after 3 years
I can't claim this as my own idea because I saw this from another Smartsheet user in a webinar and started implementing it. Now that Smartsheet offers Sheet level comments, we store this type of info…1 · -
Re: How to copy part of a text into a Smartsheet ?
Gotcha. If you want an end to the part that grabs the text, you will need to provide the position that the function needs to stop. Also, the function RIGHT is not the correct function anymore, as we'…1 · -
Re: Count What is Due for Today and the next 7 days
No problem. I'm glad it's working1 · -
Re: COUNTIF, Cross Sheet, Multiple Contacts
Looks like you might just be missing a comma before your HAS function: =COUNTIF({Internal Comms Intake Range 1}, HAS(@cell, "Amy Merck"))1 · -
Re: COUNTIF, Cross Sheet, Multiple Contacts
Are you putting the formula in a column of type Contact List? If so, that column is expecting a contact to be entered and won't show a value for your COUNTIF formula. You'll need to either put your f…1 ·